/*
 Navicat Premium Dump SQL

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 127.0.0.1:3306
 Source Schema         : smart_community

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 08/09/2025 14:09:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_property_company_community
-- ----------------------------
DROP TABLE IF EXISTS `sc_property_company_community`;
CREATE TABLE `sc_property_company_community` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'å…³è”ID',
  `property_company_id` bigint(20) NOT NULL COMMENT 'ç‰©ä¸šå…¬å¸ID',
  `community_id` bigint(20) NOT NULL COMMENT 'ç¤¾åŒºID',
  `contract_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'åˆåŒç¼–å·',
  `service_content` text COLLATE utf8mb4_unicode_ci COMMENT 'æœåŠ¡å†…å®¹',
  `service_fee` decimal(10,2) DEFAULT NULL COMMENT 'æœåŠ¡è´¹ç”¨',
  `service_start_date` date DEFAULT NULL COMMENT 'æœåŠ¡å¼€å§‹æ—¥æœŸ',
  `service_end_date` date DEFAULT NULL COMMENT 'æœåŠ¡ç»“æŸæ—¥æœŸ',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'çŠ¶æ€ï¼š0-ç»ˆæ­¢ï¼Œ1-æ­£å¸¸ï¼Œ2-æš‚åœ',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'åˆ›å»ºæ—¶é—´',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'æ›´æ–°æ—¶é—´',
  `create_by` bigint(20) DEFAULT NULL COMMENT 'åˆ›å»ºäººID',
  `update_by` bigint(20) DEFAULT NULL COMMENT 'æ›´æ–°äººID',
  `version` int(11) NOT NULL DEFAULT '0' COMMENT 'ä¹è§‚é”ç‰ˆæœ¬å·',
  `remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'å¤‡æ³¨',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_property_company_community` (`property_company_id`,`community_id`),
  KEY `idx_property_company_id` (`property_company_id`),
  KEY `idx_community_id` (`community_id`),
  KEY `idx_status` (`status`),
  KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='ç‰©ä¸šå…¬å¸ç¤¾åŒºå…³è”è¡¨';

-- ----------------------------
-- Records of sc_property_company_community
-- ----------------------------
BEGIN;
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (1, 1, 1, 'HT2025001', '物业管理服务，包括安保、清洁、绿化、维护等。', 50000.00, '2025-01-01', '2025-12-31', 1, '2025-07-08 16:14:01', '2025-08-11 09:01:54', 1, NULL, 0, '例如：物业管理公司与社区之间的联系');
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (2, 1, 2, 'HT2025002', '物业管理服务，包括安保、清洁、绿化、维护等。', 45000.00, '2025-01-01', '2025-12-31', 1, '2025-07-08 16:14:01', '2025-08-11 09:01:55', 1, NULL, 0, '例如：物业管理公司与社区之间的联系');
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (3, 2, 3, 'HT2025003', '物业管理服务，包括安保、清洁、绿化、维护等。', 60000.00, '2025-01-01', '2025-12-31', 1, '2025-07-08 16:14:01', '2025-08-11 09:01:56', 1, NULL, 0, '例如：物业管理公司与社区之间的联系');
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (4, 1, 4, 'HT2025004', '物业管理服务，包括安保、清洁、绿化、维护等。', 55000.00, '2025-01-01', '2025-12-31', 1, '2025-07-08 16:14:01', '2025-08-11 09:01:58', 1, NULL, 0, '例如：物业管理公司与社区之间的联系');
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (5, 2, 5, NULL, NULL, NULL, NULL, NULL, 1, '2025-07-12 15:21:49', '2025-07-12 15:22:15', 9, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (6, 2, 9, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-08 14:11:14', '2025-08-08 14:11:14', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (7, 1012, 10, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-08 16:18:57', '2025-08-08 16:18:57', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (8, 1012, 11, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-10 00:10:36', '2025-08-10 00:10:36', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (9, 1013, 12, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-12 13:31:41', '2025-08-12 13:31:41', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (10, 1012, 13, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-12 14:40:27', '2025-08-12 14:40:27', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (11, 1012, 14, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-12 16:09:34', '2025-08-12 16:09:34', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (12, 1012, 15, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-12 16:59:53', '2025-08-12 16:59:53', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (13, 1012, 16, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-12 17:38:44', '2025-08-12 17:38:44', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (14, 1014, 17, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-14 10:20:29', '2025-08-14 10:20:29', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (15, 1012, 18, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-15 15:17:03', '2025-08-15 15:17:03', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (16, 1014, 19, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-15 15:36:28', '2025-08-15 15:36:28', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (17, 1014, 20, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-15 15:44:39', '2025-08-15 15:44:39', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (18, 1010, 21, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-18 18:01:33', '2025-08-18 18:01:33', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (19, 1, 22, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-21 09:40:22', '2025-08-21 09:40:22', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (20, 1015, 23, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-28 10:22:47', '2025-08-28 10:22:47', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (21, 1015, 24, NULL, NULL, NULL, NULL, NULL, 1, '2025-08-28 13:46:06', '2025-08-28 13:46:06', NULL, NULL, 0, NULL);
INSERT INTO `sc_property_company_community` (`id`, `property_company_id`, `community_id`, `contract_no`, `service_content`, `service_fee`, `service_start_date`, `service_end_date`, `status`, `create_time`, `update_time`, `create_by`, `update_by`, `version`, `remark`) VALUES (22, 1015, 25, NULL, NULL, NULL, NULL, NULL, 1, '2025-09-08 13:30:25', '2025-09-08 13:30:25', NULL, NULL, 0, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
